# https://www.bilibili.com/video/BV1W7411G7wP?p=1&vd_source=8bd7b24b38e3e12c558d839b352b32f4
import pandas as pd

data = {'ID':[1, 2, 3], 'Name':['Tim', 'Victor', 'Nick']}

df = pd.DataFrame(data)         # 默认索引
df = df.set_index('ID')         # 使用ID这列做索引
df.to_excel('../resources/output/hello.xlsx')
print('done!')